SQL provides a WHERE clause that is used to filter records.

It is used like this:

select * from products where price > 50

The following operators are supported:

= Equal to
select * from products where price = 50
would show all products that cost $50

> greater than

< less than

>= greater than or equal to

<= less than or equal to